 create external table jms_dm.dm_dispatch_staff_count (
date_time date COMMENT '签收日期' ,
dispatch_network_code string COMMENT '派件网点code' ,
dispatch_network_name string COMMENT '派件网点name' ,
dispatch_staff_code string COMMENT '派件员code' ,
dispatch_staff_name string COMMENT '派件员' ,
dispatch_finance_code string COMMENT '派件财务中心code' ,
dispatch_finance_name string COMMENT '派件财务中心名称' ,
franchisee_code string COMMENT '加盟商' ,
franchisee_name string COMMENT '加盟商' ,
bill_count bigint COMMENT '派件总票数' ,
refund_count bigint COMMENT '退件票数' ,
charge_weight decimal(16,4)  COMMENT '总内部计费重量' )
comment '收派员件量统计-派件员'
PARTITIONED BY ( dt string COMMENT '时间分区')
stored as parquet
LOCATION '/dw/hive/jms_dm.db/external/dm_dispatch_staff_count'
TBLPROPERTIES (     'discover.partitions' = 'false' ,
 'parquet.column.index.access' = 'true');